﻿<%@ Page MasterPageFile="~/MasterPage.master" Language="C#" AutoEventWireup="true" CodeFile="AddCircle.aspx.cs" Inherits="AddCircle" Theme="Theme1" %>


<asp:Content ID="content1" runat="server" ContentPlaceHolderID="MainContentPlaceHolder"> 

    <div style="text-align: center">
      <table width="800" border="0" cellspacing="0" cellpadding="0" style="background-color:#ffffff">
        <tr>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td>
              <table cellpadding="0" cellspacing="0" 
                  
                  style="width: 718px; vertical-align: top; background-color: #C0C0C0; height: 481px;">
                  <tr>
                      <td class="style4" style="vertical-align: top">
                          <table cellpadding="0" cellspacing="0" style="width: 174px; height: 111px;">
                              <tr>
                                  <td>
                                      <a href= "AddDistrict.aspx"> District Details</a></td>
                                        </tr>
                                        <tr>
                                            <td>
                                                <a href="AddCircle.aspx"> Circle Details</a></td>
                                        </tr>
                                        <tr>
                                            <td>
                                                <a href= "AddPoliceStation.aspx"> PoliceStation Details</a></td>
                                        </tr>
                                        <tr>
                                            <td>
                                               <a href="anonymous/GenerateFIR.aspx"> GenerateFIR </a></td>
                                        </tr>
                                        <tr>
                                            <td>
                                                <a href="WitnessDetails.aspx">Witness Details</a></td>
                                        </tr>
                                        <tr>
                                            <td>
                                                <a href="AddMurderDetail.aspx">Murder Record</a></td>
                                        </tr>
                                        <tr>
                                            <td>
                                                <a href="FIRDetails.aspx" >FIR Records</a></td>
                                        </tr>
                                    </table>
                                </td>
                                <td>
                                    <table cellpadding="0" cellspacing="0" 
                                        style="width: 760px; background-color: #FFFFCC; height: 345px;">
                                        <tr>
                                            <td colspan="3">
                                                <asp:Label ID="Label1" runat="server" BackColor="#666699" ForeColor="White" 
                                                    SkinID="Label1" style="font-weight: 700; font-style: italic; font-size: large" 
                                                    Text=" Circle Details" Width="520px"></asp:Label>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td class="style3">
                                                &nbsp;</td>
                                            <td style="text-align: left" colspan="2">
                                                &nbsp;</td>
                                        </tr>
                                        <tr>
                                            <td class="style3">
                                                <asp:SqlDataSource ID="CircleSqlDataSource1" runat="server" 
                                                    ConnectionString="<%$ ConnectionStrings:PAS_DB %>" 
                                                    SelectCommand="SELECT * FROM [CircleTab]" 
                                                    DeleteCommand="DELETE FROM [CircleTab] WHERE [SNo] = @SNo" 
                                                    InsertCommand="INSERT INTO [CircleTab] ([DCode], [CCode], [CName]) VALUES (@DCode, @CCode, @CName)" 
                                                    UpdateCommand="UPDATE [CircleTab] SET [DCode] = @DCode, [CCode] = @CCode, [CName] = @CName WHERE [SNo] = @SNo">
                                                    <DeleteParameters>
                                                        <asp:Parameter Name="SNo" Type="Int32" />
                                                    </DeleteParameters>
                                                    <UpdateParameters>
                                                        <asp:Parameter Name="DCode" Type="Int32" />
                                                        <asp:Parameter Name="CCode" Type="Int32" />
                                                        <asp:Parameter Name="CName" Type="String" />
                                                        <asp:Parameter Name="SNo" Type="Int32" />
                                                    </UpdateParameters>
                                                    <InsertParameters>
                                                        <asp:Parameter Name="DCode" Type="Int32" />
                                                        <asp:Parameter Name="CCode" Type="Int32" />
                                                        <asp:Parameter Name="CName" Type="String" />
                                                    </InsertParameters>
                                                </asp:SqlDataSource>
                                            </td>
                                            <td colspan="2">
                                                &nbsp;</td>
                                        </tr>
                                        <tr>
                                            <td class="style3" colspan="2">
                                                <asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" 
                                                    DataSourceID="CircleSqlDataSource1" Height="50px" Width="503px" 
                                                    AllowPaging="True" CellPadding="4" ForeColor="#333333" GridLines="None">
                                                    <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
                                                    <CommandRowStyle BackColor="#FFFFC0" Font-Bold="True" />
                                                    <RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
                                                    <FieldHeaderStyle BackColor="#FFFF99" Font-Bold="True" />
                                                    <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
                                                    <Fields>
                                                        <asp:BoundField DataField="SNo" HeaderText="SNo" InsertVisible="False" 
                                                            ReadOnly="True" SortExpression="SNo" />
                                                        <asp:BoundField DataField="DCode" HeaderText="District Code" SortExpression="DCode" />
                                                        <asp:BoundField DataField="CCode" HeaderText="Circle Code" SortExpression="CCode" />
                                                        <asp:BoundField DataField="CName" HeaderText="Circle Name" SortExpression="CName" />
                                                        <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" 
                                                            ShowInsertButton="True" />
                                                    </Fields>
                                                    <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
                                                    <AlternatingRowStyle BackColor="White" />
                                                </asp:DetailsView>
                                            </td>
                                            <td>
                                                &nbsp;</td>
                                        </tr>
                                        <tr>
                                            <td class="style1" colspan="3">
                                                &nbsp;</td>
                                        </tr>
                                        <tr>
                                            <td class="style3">
                                                &nbsp;</td>
                                            <td colspan="2">
                                                &nbsp;</td>
                                        </tr>
                                        <tr>
                                            <td class="style3">
                                                &nbsp;</td>
                                            <td colspan="2">
                                                &nbsp;</td>
                                        </tr>
                                    </table>
                                </td>
                            </tr>
                        </table>
            </td>
        </tr>
        </table>
    </div>

</asp:Content>